TMSCompactConnection Members

TMSCompactConnection class overview.

Properties

Name	Description
ClientVersion (inherited from TCustomMSConnection)	Contains the version of Microsoft OLE DB Provider for SQL Server.
ConnectDialog (inherited from TCustomDAConnection)	Allows to link a TCustomConnectDialog component.
ConnectString (inherited from TCustomDAConnection)	Used to specify the connection information, such as: UserName, Password, Server, etc.
ConvertEOL (inherited from TCustomDAConnection)	Allows customizing line breaks in string fields and parameters.
Database	Used to specify the database name that is a default source of data for SQL queries once a connection is established.
InitMode	Used to specify the file mode to be used for opening a database file.
InTransaction (inherited from TCustomDAConnection)	Indicates whether the transaction is active.
IsolationLevel (inherited from TCustomMSConnection)	Used to specify the extent to which all outside transactions interfere with subsequent transactions of the current connection.
LockEscalation	Specifies the number of locks to perform before escalating from row to table or from page to table..
LockTimeout	Used to specify the time for which a transaction will wait for a lock.
LoginPrompt (inherited from TCustomDAConnection)	Specifies whether a login dialog appears immediately before opening a new connection.
Options	Used to specify the behaviour of a TMSCompactConnection object.
Password (inherited from TCustomDAConnection)	Serves to supply a password for login.
Pooling (inherited from TCustomDAConnection)	Enables or disables using connection pool.
PoolingOptions (inherited from TCustomDAConnection)	Specifies the behaviour of connection pool.
Server (inherited from TCustomDAConnection)	Serves to supply the server name for login.
ServerVersion (inherited from TCustomMSConnection)	Contains the exact number of the SQL Server version.
TransactionCommitMode	Used to specify the way the buffer pool will be flushed on transaction commit.
Username (inherited from TCustomDAConnection)	Used to supply a user name for login.

Methods

Name	Description
ApplyUpdates (inherited from TCustomDAConnection)	Overloaded. Applies changes in datasets.
AssignConnect (inherited from TCustomMSConnection)	Shares database connection between the TCustomMSConnection components.
Commit (inherited from TCustomDAConnection)	Commits current transaction.
Connect (inherited from TCustomDAConnection)	Establishes a connection to the server.
CreateDataSet (inherited from TCustomMSConnection)	Returns a new object of the TCustomMSDataset class and associates it with this connection object.
CreateSQL (inherited from TCustomMSConnection)	Returns a new instance of the TMSSQL class and associates it with this connection object.
Disconnect (inherited from TCustomDAConnection)	Performs disconnect.
ExecProc (inherited from TCustomDAConnection)	Allows to execute stored procedure or function providing its name and parameters.
ExecProcEx (inherited from TCustomDAConnection)	Allows to execute a stored procedure or function.
ExecSQL (inherited from TCustomDAConnection)	Executes a SQL statement with parameters.
ExecSQLEx (inherited from TCustomDAConnection)	Executes any SQL statement outside the TQuery or TSQL components.
GetDatabaseNames (inherited from TCustomDAConnection)	Returns a database list from the server.
GetKeyFieldNames (inherited from TCustomDAConnection)	Provides a list of available key field names.
GetStoredProcNames (inherited from TCustomDAConnection)	Returns a list of stored procedures from the server.
GetTableNames (inherited from TCustomDAConnection)	Provides a list of available tables names.
MonitorMessage (inherited from TCustomDAConnection)	Sends a specified message through the TCustomDASQLMonitor component.
OpenDatasets (inherited from TCustomMSConnection)	Opens several datasets as one batch.
Ping (inherited from TCustomDAConnection)	Used to check state of connection to the server.
RemoveFromPool (inherited from TCustomDAConnection)	Marks the connection that should not be returned to the pool after disconnect.
Rollback (inherited from TCustomDAConnection)	Discards all current data changes and ends transaction.
StartTransaction (inherited from TCustomDAConnection)	Begins a new user transaction.

Events

Name	Description
OnConnectionLost (inherited from TCustomDAConnection)	This event occurs when connection was lost.
OnError (inherited from TCustomDAConnection)	This event occurs when an error has arisen in the connection.

Request Support

DAC Forum

Provide Feedback